package com.xiaozhengkeji.colastartboot.base.mapper;

import com.xiaozhengkeji.colastartboot.base.entitys.SystemUser;
import java.time.LocalDateTime;
import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

@Mapper
public interface SystemUserMapper {
    /**
     * delete by primary key
     *
     * @param uid primaryKey
     * @return deleteCount
     */
    int deleteByPrimaryKey(Integer uid);

    /**
     * insert record to table
     *
     * @param record the record
     * @return insert count
     */
    int insert(SystemUser record);

    /**
     * insert record to table selective
     *
     * @param record the record
     * @return insert count
     */
    int insertSelective(SystemUser record);

    /**
     * select by primary key
     *
     * @param uid primary key
     * @return object by primary key
     */
    SystemUser selectByPrimaryKey(Integer uid);

    /**
     * update record selective
     *
     * @param record the updated record
     * @return update count
     */
    int updateByPrimaryKeySelective(SystemUser record);

    /**
     * update record
     *
     * @param record the updated record
     * @return update count
     */
    int updateByPrimaryKey(SystemUser record);

    List<SystemUser> queryByAll(SystemUser systemUser);

    List<SystemUser> queryByUsername(@Param("username") String username);

    List<SystemUser> queryByUsernameLike(@Param("likeUsername") String likeUsername);

    List<SystemUser> queryByEmail(@Param("email") String email);

    List<SystemUser> queryByEmailAndPassword(@Param("email") String email, @Param("password") String password);

    List<SystemUser> queryByEmailLike(@Param("likeEmail") String likeEmail);

    List<SystemUser> queryByUsernameAndPassword(@Param("username") String username, @Param("password") String password);
}